Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# V$SES_OPTIMIZER_ENV

`V$SES_OPTIMIZER_ENV` displays the contents of the optimizer environment used by each session. When a new session is first created, it automatically inherits its optimizer environment from the optimizer environment defined at the instance level by `V$SYS_OPTIMIZER_ENV`. The value of certain parameters can be dynamically modified by issuing an `ALTER SESSION` statement.

Column | Datatype | Description
--- | --- | ---
`SID` | `NUMBER` | Session identifier. This column can be used to join with `V$SESSION` on the `SID` column.
`ID` | `NUMBER` | Unique identifier of the parameter in the optimizer environment
`NAME` | `VARCHAR2(40)` | Name of the parameter
`ISDEFAULT` | `VARCHAR2(3)` | Indicates whether the parameter is set to the default value (`YES`) or not (`NO`)
`VALUE` | `VARCHAR2(25)` | Value of the parameter for the session

See Also: "V$SYS_OPTIMIZER_ENV"